APDISTRIB – Invoice Distribution

System
Accounts Payable (AP)
Prefix
APD
Primary key
API-OBJ-ID, DIST-SEQ-NBR
Fields
74
Updated by
72 programs
Referenced by
19 programs

APDISTRIB is the Invoice Distribution table in Lawson Accounts Payable (prefix APD). It is indexed by API-OBJ-ID, DIST-SEQ-NBR (APDSET1); alternate indexes: APDSET10, APDSET11, APDSET12, APDSET13, APDSET2, APDSET3, APDSET4, APDSET5 and 4 more. It is related 1:1 to ACTRANS, APCOMPANY, GLSYSTEM, APDSTBOD, APINVOICE, APPROCLEV, APUAVAL, APVENMAST and 7 more and 1:M to APDISTPAY, APDISTRIB, APVENDIV, PDCHRGDIST and SLTRANS. It is updated by AP115, AP125, AP126, AP170, AP175, AP177, AP178, AP180 and 64 more and referenced by AP00.4, AP136, AP212, AP220, AP232, AP233, AP271, AP272 and 11 more. The table has 74 fields, 13 indexes and 23 documented relations.

About APDISTRIB

The Invoice Distribution Header file contains invoice distribution records. The presence of a tax code identifies the record as a tax distribution. Distribution records that have an asset number or asset template assigned will also have an associated record in the Asset Detail file.

Fields (74)

Column = COBOL field name without the APD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
APD-COMPANY
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
APD-API-OBJ-ID PK
API_OBJ_ID		Numeric 12A unique identifier assigned to this file record.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +40 more
APD-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor number. Must be a valid record in the Vendor file.AP115, AP125, AP126, AP170, AP180, AP181, AP190, AP191 +38 more
APD-INVOICE
INVOICE		Alpha 22The invoice number. Represents a unique identifier for the invoice. Must be a valid record in the Accounts Payable Invoice file.AP115, AP125, AP126, AP170, AP180, AP181, AP190, AP191 +38 more
APD-SUFFIX
SUFFIX		Numeric 3The invoice suffix number. Represents the occurrence value of the invoice. The suffix is assigned by the system to recurring invoices, employee advances, and prepayment credit memos.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +36 more
APD-CANCEL-SEQ
CANCEL_SEQ		Numeric 4The sequence number assigned upon the cancellation of a distributed invoice. The first sequence assigned is 9999.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +34 more
APD-ORIG-DIST-SEQ
ORIG_DIST_SEQ		Numeric 6A unique sequence number.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +23 more
APD-DIST-SEQ-NBR PK
DIST_SEQ_NBR		Numeric 6A unique sequence number assigned to the distribution record.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +44 more
APD-DIST-TYPE
DIST_TYPE		Alpha 1The distribution type. Valid values are: used for distributions that originate in the Accounts Payable system.)
  • D Distribution.
  • I Intercompany Distribution. (Not
  • G Gain/Loss Distribution.
  • R Tax/Reversal Distribution.
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
APD-PROC-LEVEL
PROC_LEVEL		Alpha 5The process level associated with the distribution. Must be a valid record in the Accounts Payable Process Level file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +38 more
APD-POST-OPTION
POST_OPTION		Alpha 1The general ledger posting option associated with the distribution record. Valid values are:
  • D Detail.
  • S Summary.
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +36 more
APD-INVOICE-TYPE
INVOICE_TYPE		Alpha 1The type of invoice associated with the distribution. Valid values are:
  • Blank Invoice.
  • C Credit Memo.
  • D Debit Memo.
  • P Prepayment.
  • Y Prepayment Credit Memo.
  • A Employee Advance.
  • M Employee Advance Credit Memo.
  • E Employee Expense.
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +36 more
APD-REC-STATUS
REC_STATUS		Numeric 1The distribution record status. Valid values are:
  • 0 Unreleased.
  • 1 Unposted (released).
  • 9 Posted by AP175.
  • 5 Pending
  • 6 Approved
  • 7 Rejected
AP125, AP126, AP170, AP175, AP180, AP181, AP190, AP191 +45 more
APD-INV-CURRENCY
INV_CURRENCY		Alpha 5The currency of the invoice. Must be a valid record in the Currency Code file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
APD-TAX-RATE
TAX_RATE		Percent 7.5 (Percent)The tax rate applied to the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +39 more
APD-CURR-RATE
CURR_RATE		Signed 14.7The currency exchange rate applied to the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +43 more
APD-ORIG-BASE-AMT
ORIG_BASE_AMT		Signed 18.2The amount of the distribution in company base currency.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +42 more
APD-BASE-ND
BASE_ND		Numeric 1The number of decimals positions defined for the company base currency.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
APD-ORIG-TRAN-AMT
ORIG_TRAN_AMT		Signed 18.2The amount of the distribution in the currency of the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
APD-TRAN-ND
TRAN_ND		Numeric 1The number of decimals defined for the invoice currency.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
APD-TO-BASE-AMT
TO_BASE_AMT		Signed 18.2The amount of the distribution in the distribution company's base currency.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +43 more
APD-TO-BASE-ND
TO_BASE_ND		Numeric 1The number of decimal positions defined for the distribution company's currency.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
APD-TAXABLE-AMT
TAXABLE_AMT		Signed 18.2The taxable amount of the distribution.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +34 more
APD-UNT-AMOUNT
UNT_AMOUNT		Signed 18.2The total unit amount allocated to the expense distribution.AP125, AP126, AP180, AP181, AP190, AP191, AP20.1, AP20.2 +33 more
APD-DIST-COMPANY
DIST_COMPANY		Numeric 4The distribution company assigned to the distribution. Must be a valid record in the General Ledger Company file and a valid relationship record must exist in the Intercompany Relationship file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
APD-DIS-ACCT-UNIT
DIS_ACCT_UNIT		Alpha 15The general ledger distribution accounting unit. Must be a valid record in the General Ledger Names file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
APD-DIS-ACCOUNT
DIS_ACCOUNT		Numeric 6The general ledger distribution account number. Must be a valid record in the General Ledger Account Master file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
APD-DIS-SUB-ACCT
DIS_SUB_ACCT		Numeric 4The general ledger distribution subaccount number. Must be a valid record in the General Ledger Account Master file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
APD-DISTRIB-DATE
DISTRIB_DATE		Numeric 8 (yyyymmdd)The date used for posting the distribution to the general ledger.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +41 more
APD-TAX-INDICATOR
TAX_INDICATOR		Numeric 10
  • 1 Exempt
  • 2 Taxable
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +33 more
APD-TAX-SEQ-NBR
TAX_SEQ_NBR		Numeric 4—AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +23 more
APD-TAX-CODE
TAX_CODE		Alpha 10The tax code assigned to the distribution. Represents tax information. If present, identifies the distribution as a tax distribution. Must be a valid tax code in Tax.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +34 more
APD-TAX-TYPE
TAX_TYPE		Alpha 1Indicates the type of tax defined for the Tax Code. Valid values are: represents an increase to the invoice amount. the invoice amount.
  • I Invoiced. Default value. The tax
  • A Accrued. The tax does not increase
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +39 more
APD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The distribution description.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
APD-DST-REFERENCE
DST_REFERENCE		Alpha 10The distribution reference.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +34 more
APD-ACTIVITY
ACTIVITY		Alpha 15The activity assigned to the distribution, if applicable. Used to group expense distribution amounts to track costs for projects, jobs, construction, and so on, without having to define additional general ledger account numbers. Must be a valid activity in Project Accounting.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
APD-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The account category assigned to the distribution, if applicable. Used to group distributions under an activity. Must be a valid account category for the activity in Project Accounting.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +39 more
APD-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +23 more
APD-ACCR-CODE
ACCR_CODE		Alpha 4The invoice accrual code associated with the distribution. Represents a general ledger accrual account. Must be a valid record in the Invoice Accrual Code file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +43 more
APD-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +28 more
APD-PO-RELEASE
PO_RELEASE		Numeric 4The purchase order release number associated with the distribution. Used to identify a purchase order release (created from a blanket or standing order).AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +28 more
APD-PO-CODE
PO_CODE		Alpha 4Purchase order number code. Used to keep purchase orders unique. Can also be used for reporting purposes.AP125, AP126, AP170, AP180, AP181, AP190, AP20.1, AP20.2 +27 more
APD-PO-LINE-NBR
PO_LINE_NBR		Numeric 6The purchase order line number associated with the distribution.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +28 more
APD-PO-AOC-CODE
PO_AOC_CODE		Alpha 2Indicates whether this distribution record represents an add-on cost for a purchase order. Valid values are:
  • Y Yes.
  • N No.
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +27 more
APD-GLT-OBJ-ID
GLT_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP125, AP126, AP170, AP175, AP180, AP181, AP190, AP191 +38 more
APD-ATN-OBJ-ID
ATN_OBJ_ID		Numeric 12A subsystem activity interface identification number. Used for Drill Around purposes.AP125, AP126, AP170, AP175, AP180, AP181, AP190, AP191 +38 more
APD-ASSET-FLAG
ASSET_FLAG		Alpha 1Indicates whether an asset or asset repair record exists for the distribution. Valid values are: for the distribution.
  • A Asset.
  • R Repair Asset.
  • Blank No asset information is defined
  • Y Asset or Repair
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +29 more
APD-DIST-CODE
DIST_CODE		Alpha 9The distribution code assigned to the distribution. Used to split an expense distribution into multiple distribution lines. Must be a valid record in the Distribution Code Header file.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +25 more
APD-TAX-POINT
TAX_POINT		Alpha 1Indicates when the tax amount is calculated for the invoice distribution, if applicable. Valid values are:
  • I Invoice.
  • P Payment.
  • G GL Post Date
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +32 more
APD-VAT-REVERSE-FL
VAT_REVERSE_FL		Alpha 1Used in AP190 (Invoice Reinstatement) to create reversing tax due general ledger records. This field is No if reversing tax transactions have not been sent to the general ledger. When the transactions are sent to the general ledger, this field changes to Yes. Valid values are:
  • N No.
  • Y Yes.
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +24 more
APD-DST-OBJ-ID
DST_OBJ_ID		Numeric 12An object identifier to keep the record unique.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
APD-MA-CREATE-FL
MA_CREATE_FL		Alpha 1Indicates the distribution was generated during matching, as opposed to entered manually during invoicing. Also used during the match reversal process to determine whether the distribution should be deleted (match distribution) or left untouched (miscellaneous distribution).AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +25 more
APD-TAX-USAGE-CD
TAX_USAGE_CD		Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +27 more
APD-TRAN-DIST-FLAG
TRAN_DIST_FLAG		Alpha 1—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
APD-PULL-FOR-FR-FL
PULL_FOR_FR_FL		Alpha 1—AP175, AP177
APD-AC-UPD-STATUS
AC_UPD_STATUS		Numeric 1AC provides status that the activity reflects "cash basis" billing. Status change will reflect AP invoice for distibution has been paid and message of payment has been sent to AC.
  • 0 No payment information impact
  • 1 Requires payment information
  • 9 AP invoice paid. AC updated.
AP125, AP126, AP175, AP178, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
APD-AC-UPD-DATE
AC_UPD_DATE		Numeric 8 (yyyymmdd)Last Ac distribtion record status change date.AP125, AP126, AP175, AP178, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
APD-AC-UPD-TIME
AC_UPD_TIME		Numeric 6 (hhmmss)Last AC distribution record change time.AP125, AP126, AP175, AP178, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
APD-DIVERSE-CODE
DIVERSE_CODE		Alpha 5Diversity Code for Account Payable VendorsAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +19 more
APD-DISTRIB-ADJ
DISTRIB_ADJ		Numeric 1Identifies distribution as one that was created from AP30.2 Distribution Adjustments. If created in AP30.2 form value equal to '1'. Used to determine source code to send to GLTRANS and ACTRANS. 0
  • 1 Distribution Adjustment
AP30.2
APD-DIST-STATUS
DIST_STATUS		DerivedIndicates whether the distribution is posted or unposted.—
APD-TAX-FLAG
TAX_FLAG		Alpha 1—TX101
APD-ICN-CODE
ICN_CODE		Alpha 8—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +13 more
APD-WEIGHT
WEIGHT		Signed 9.3This field contains the unit weight of the item based on the stocking UOM.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +13 more
APD-SUPLMNTARY-QTY
SUPLMNTARY_QTY		Signed 13.4This field contains the desired quantity.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +13 more
APD-LINE-TYPE
LINE_TYPE		Alpha 1This field contains the type of inventory on this line.
  • G Goods
  • S Service
AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +13 more
APD-STATEMENT
STATEMENT		Alpha 22Used to identify the invoice.API1.1, PD20.1, PD20.2, PD20.3
APD-TXN-NBR
TXN_NBR		Alpha 22—API1.1, PD20.1, PD20.2, PD20.3
APD-RETAINAGE
RETAINAGE		Numeric 1—
  • 0 No
  • 1 Yes
AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +19 more
APD-PROD-TAX-CAT
PROD_TAX_CAT		Alpha 15—AP125, AP126, AP170, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +20 more
APD-CREATED-BY
CREATED_BY		Alpha 10—AP115, AP125, AP126, AP170, AP180, AP181, AP190, AP191 +38 more
APD-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP115, AP125, AP126, AP170, AP175, AP177, AP178, AP180 +52 more (list truncated in source)
APD-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP115, AP125, AP126, AP170, AP175, AP177, AP178, AP180 +52 more (list truncated in source)
APD-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP115, AP125, AP126, AP170, AP175, AP177, AP178, AP180 +52 more (list truncated in source)

Indexes (13)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APDSET1API-OBJ-ID, DIST-SEQ-NBRPrimaryAP115, AP125, AP126, AP136, AP170, AP175, AP178, AP180 +22 more (list truncated in source)
APDSET10API-OBJ-ID, ORIG-DIST-SEQ, TAX-SEQ-NBRKeyChange, SubsetWhere (ORIG-DIST-SEQ != Zeroes) And (TAX-SEQ-NBR != Zeroes)AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +15 more
APDSET11COMPANY, API-OBJ-ID, DIST-SEQ-NBRSubsetWhere (PULL-FOR-FR-FL = "Y")AP177
APDSET12COMPANY, STATEMENT, TXN-NBR, API-OBJ-ID, DIST-SEQ-NBRSubsetWhere (PO-NUMBER = Spaces) And (STATEMENT != Spaces)—
APDSET13COMPANY, DISTRIB-DATE, LAST-UPDT-DATE, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, PROC-LEVEL, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT, API-OBJ-ID, DIST-SEQ-NBRKeyChange—
APDSET2COMPANY, REC-STATUS, PROC-LEVEL, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT, DISTRIB-DATE, API-OBJ-ID, DIST-SEQ-NBRKeyChangeAP00.4, AP175, AP178, AP195, AP211, TX101
APDSET3DIST-COMPANY, ACTIVITY, ACCT-CATEGORY, DISTRIB-DATE, API-OBJ-ID, DIST-SEQ-NBRKeyChangeAP95.2, AP95.3
APDSET4DIST-COMPANY, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT, DISTRIB-DATE, API-OBJ-ID, DIST-SEQ-NBRKeyChangeAP237, AP275, AP95.2, AP95.3
APDSET5GLT-OBJ-ID, API-OBJ-ID, DIST-SEQ-NBRKeyChange, SubsetWhere GLT-OBJ-ID != ZeroesMM280, MM80.1, MM80.2
APDSET6DST-OBJ-IDKeyChange, SubsetWhere DST-OBJ-ID != Zeroes—
APDSET7VENDOR, API-OBJ-ID, DIST-SEQ-NBRAP272, AP36.2, TX101
APDSET8COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, PO-LINE-NBR, PO-AOC-CODE, API-OBJ-ID, DIST-SEQ-NBRKeyChange, SubsetWhere PO-NUMBER != SpacesAP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +8 more
APDSET9ATN-OBJ-ID, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, DIST-SEQ-NBRKeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—

Relations

One to one (18) — lookups and parents

RelationTableRulesConditionField map
ActransACTRANSNot RequiredAPD-ATN-OBJ-ID → -OBJ-ID (XXXXXXXXXX)
ApcompanyAPCOMPANYRequiredAPD-COMPANY → CPY-COMPANY
ApdistcompanyGLSYSTEMRequiredAPD-DIST-COMPANY → GLS-COMPANY
ApdstbodAPDSTBODNot Required, Delete CascadesAPD-API-OBJ-ID → YAY-API-OBJ-ID, APD-DIST-SEQ-NBR → YAY-DIST-SEQ-NBR
ApinvoiceAPINVOICERequiredAPD-COMPANY → API-COMPANY, APD-VENDOR → API-VENDOR, APD-INVOICE → API-INVOICE, APD-SUFFIX → API-SUFFIX, APD-CANCEL-SEQ → API-CANCEL-SEQ
ApproclevAPPROCLEVRequiredAPD-COMPANY → APR-COMPANY, APD-PROC-LEVEL → APR-PROC-LEVEL
ApuavalAPUAVALNot Required"D" → UAV-SEG-TYPE, APD-API-OBJ-ID → UAV-API-OBJ-ID, APD-DIST-SEQ-NBR → UAV-DIST-SEQ-NBR
ApvenmastAPVENMASTRequiredCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, APD-VENDOR → VEN-VENDOR
AssetAPASTDTLNot RequiredAPD-API-OBJ-ID → APS-API-OBJ-ID, APD-DIST-SEQ-NBR → APS-DIST-SEQ-NBR
DistribprocAPPROCLEVRequiredAPD-COMPANY → APR-COMPANY, APD-PROC-LEVEL → APR-PROC-LEVEL
DstusrfldAPDSUSRFLDNot RequiredAPD-API-OBJ-ID → DFL-API-OBJ-ID, APD-DIST-SEQ-NBR → DFL-DIST-SEQ-NBR
GlmasterGLMASTERRequiredAPD-DIST-COMPANY → GLM-COMPANY, APD-DIS-ACCT-UNIT → GLM-ACCT-UNIT, APD-DIS-ACCOUNT → GLM-ACCOUNT, APD-DIS-SUB-ACCT → GLM-SUB-ACCOUNT
GlnamesGLNAMESRequiredAPD-DIST-COMPANY → GLN-COMPANY, APD-DIS-ACCT-UNIT → GLN-ACCT-UNIT
Glsystem OrigGLSYSTEMRequiredAPD-COMPANY → GLS-COMPANY
Glsystem ToGLSYSTEMRequiredAPD-DIST-COMPANY → GLS-COMPANY
PdchrgapiPDCHRGAPINot RequiredAPD-API-OBJ-ID → PDO-API-OBJ-ID, APD-STATEMENT → PDO-STATEMENT
PdchrgdtlPDCHRGDTLNot RequiredValid When (APD-PO-NUMBER = Spaces) And (APD-STATEMENT != Spaces)PDO-PCARD-PROGRAM → PXD-PCARD-PROGRAM, APD-STATEMENT → PXD-STATEMENT, APD-COMPANY → PXD-COMPANY, APD-TXN-NBR → PXD-TXN-NBR
PorebdistPOREBDISTRequiredAPD-API-OBJ-ID → RDS-API-OBJ-ID, APD-DIST-SEQ-NBR → RDS-DIST-SEQ-NBR

One to many (5) — child tables

RelationTableRulesConditionField map
ApdistpayAPDISTPAYAPD-COMPANY → DTY-COMPANY, APD-VENDOR → DTY-VENDOR, APD-INVOICE → DTY-INVOICE, APD-SUFFIX → DTY-SUFFIX, APD-DIST-SEQ-NBR → DTY-DIST-SEQ-NBR, → DTY-LINE-NBR, → DTY-MAD-SEQ-NBR, → DTY-PMT-SEQ-NBR
ApdistribAPDISTRIBDelete CascadesAPD-API-OBJ-ID → APD-API-OBJ-ID, APD-DIST-SEQ-NBR → APD-ORIG-DIST-SEQ, → APD-TAX-SEQ-NBR
ApvendivAPVENDIVCPY-VENDOR-GROUP → VDC-VENDOR-GROUP, APD-VENDOR → VDC-VENDOR, API-LOCATION → VDC-LOCATION-CODE, → VDC-DIVERSE-CODE, → VDC-DCERT-DATE
PdchrgdistPDCHRGDISTPDO-PCARD-PROGRAM → PDS-PCARD-PROGRAM, APD-STATEMENT → PDS-STATEMENT, APD-COMPANY → PDS-COMPANY, APD-TXN-NBR → PDS-TXN-NBR, → PDS-SEQ-NBR
SltransSLTRANSAPD-GLT-OBJ-ID → SLT-GLT-OBJ-ID, → SLT-OBJ-ID

Programs

Updated by (72)

Referenced by (19)