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.