|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CInvoice_ID
|
Link to CInvoice
|
|
9999999999
|
|
|
|
ExpNote_ID
|
Link to ExpNote
|
|
9999999999
|
|
|
|
ExpNoteCInvoice_ID
|
Record ID
|
|
9999999999
|
|
|
|
ExpNoteCInvoiceDeductLC
|
BC Deductible
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
ExpNoteCInvoiceDeductTC
|
TC Deductible
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
ExpNoteCInvoiceIsReturned
|
Is Returned
|
Returned
|
yes/no
|
|
|
|
ExpNoteCInvoiceStatusCode
|
Status Code
|
Status
|
x(20)
|
|
|
|
ExpNoteCInvoiceToReturnTC
|
TC To Return
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
ExpNoteCInvoiceTypeCode
|
Type Code
|
Type
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CInvoice
|
no
|
CInvoice_ID
|
yes
|
no
|
|
|
ExpNote
|
no
|
ExpNote_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ExpNoteCInvoice_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
ExpNote_ID
|
yes
|
no
|
|
|
|
|
CInvoice_ID
|
yes
|
no
|