C3TAXRET

REFERENCED BY
MA540 MA61.1 MAI1.1 WH20.7


UPDATED BY
PO30.1 WH32.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
C3T-COMPANY
Element: Company
Numeric 4
PO30.1 WH32.1
C3T-C3T-TRANS-TYPE
Element: Type
Alpha 2
PO30.1 WH32.1
C3T-RECORD-TYPE
Element: Type
Alpha 2
PO30.1 WH32.1
C3T-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
PO30.1 WH32.1
C3T-INVOICE
Element: Invoice
Alpha 22
PO30.1 WH32.1
C3T-SUFFIX
Element: Suffix
Numeric 3
PO30.1 WH32.1
C3T-CANCEL-SEQ
Element: Cancel Seq
Numeric 4
PO30.1 WH32.1
C3T-SHIPMENT-NBR
Element: Shipment Nbr
Numeric 10
PO30.1 WH32.1
C3T-LOCATION
Element: Location
Alpha 5
PO30.1 WH32.1
C3T-ORDER-LINE-NBR
Element: Line Nbr
Numeric 6
PO30.1 WH32.1
C3T-BR-TAX-TYPE
Element: Br Tax Type
Alpha 15
PO30.1 WH32.1
C3T-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
PO30.1 WH32.1
C3T-ORDER-NUMBER
Element: Order Nbr
Numeric 8
PO30.1 WH32.1
C3T-REC-NUMBER
Element: Rec Number
Numeric 10
PO30.1 WH32.1
C3T-TAX-LINE
Element: Line Nbr
Numeric 6
PO30.1 WH32.1
C3T-TAX-CODE
Element: Tax Code
Alpha 10
PO30.1 WH32.1
C3T-TAX-BASE
Element: Intl Amt
Signed 18.2
PO30.1 WH32.1
C3T-TAX-RATE
Element: Percent
Signed 7.3
PO30.1 WH32.1
C3T-TAX-AMOUNT
Element: Intl Amt
Signed 18.2
PO30.1 WH32.1
C3T-TAX-RECOV-AMT
Element: Intl Amt
Signed 18.2
PO30.1 WH32.1
C3T-TAX-INC-AMT
Element: Intl Amt
Signed 18.2
PO30.1 WH32.1
C3T-TAX-DISC-AMT
Element: Intl Amt
Signed 18.2
PO30.1 WH32.1
C3T-INTST-TAX-DIFF
Element: Intl Amt
Signed 18.2
PO30.1 WH32.1
C3T-TAX-CLASS
Element: Intl Amt
Signed 18.2
PO30.1 WH32.1
C3T-GLBL-LINE-TYPE
Element: Glbl Line Type
Alpha 15
PO30.1 WH32.1
C3T-BOD-ACCT-ENT
Element: Notice Nbr
Alpha 22
PO30.1 WH32.1
C3T-BOD-LOCATION
Element: Notice Nbr
Alpha 22
PO30.1 WH32.1
C3T-BOD-DOC-ID
Element: Alpha 100
Alpha 100
PO30.1 WH32.1


C3TAXRET FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
C3TSET1 COMPANY
C3T-TRANS-TYPE
RECORD-TYPE
VENDOR
INVOICE
ORDER-NUMBER
ORDER-LINE-NBR
BR-TAX-TYPE
MA540 MA61.1
MAI1.1 PO30.1
WH32.1
C3TSET2 COMPANY
C3T-TRANS-TYPE
RECORD-TYPE
VENDOR
ORDER-NUMBER
ORDER-LINE-NBR
BR-TAX-TYPE
Subset
WhereC3T-TRANS-TYPE ="IN"
PO30.1 WH20.7
WH32.1
C3TSET3 COMPANY
C3T-TRANS-TYPE
RECORD-TYPE
VENDOR
PO-NUMBER
ORDER-LINE-NBR
BR-TAX-TYPE
Subset
WhereC3T-TRANS-TYPE ="RC"


C3TAXRET FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apinvoice APINVOICE Not Required
C3T-COMPANY->API-COMPANY (APISET1)
C3T-VENDOR->API-VENDOR
C3T-INVOICE->API-INVOICE
C3T-SUFFIX->API-SUFFIX
C3T-CANCEL-SEQ->API-CANCEL-SEQ


File created: Thu Jun 09 02:11:50 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.