SRAgreementHeader
SRCompany | SRDivision | SRAgreementNo | SRAgreementDesc |
---|---|---|---|
- | AAA | 14001001 | Variant 1 - Fixed rate, Wide selection |
- | AAA | 14001002 | Variant 2 - Fixed rate, Facility A01 Whs |
- | AAA | 14001003 | Variant 3 - Different fixed, Fac A01 Whs |
- | AAA | 14001004 | Variant 4 - USSup, Diff fixed, Faci A01 |
- | AAA | 14001005 | Variant 5 - Scaled Best Rate, Faci A01 |
- | AAA | 14001006 | Variant 6 - Base-Child |
- | AAA | 14001007 | Variant 7 - Scaled rate, Quantity unit |
SRAgrType | SRAgrGroup | SRPriority | SRStatus |
---|---|---|---|
LINE | NULL | 5 | A |
LINE | NULL | 5 | A |
LINE | NULL | 5 | A |
LINE | NULL | 5 | A |
LINE | NULL | 5 | A |
LINE | NULL | 5 | A |
LINE | NULL | 5 | A |
SRValidFrom | SRValidTo | SRAgrDate | SRSupplierNo |
---|---|---|---|
<Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 |
<Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 |
<Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 |
<Jan1 of current year> | <Dec31 of next year> | <current date> | NULL |
<Jan1 of current year> | <Dec31 of next year> | <current date> | NULL |
<Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 |
<Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 |
SRSupplierRef | SRSupplierGroup | SRSupplierTable | SRWarehouseCode |
---|---|---|---|
Variant 1 | NULL | NULL | 001 |
Variant 2 | NULL | NULL | NULL |
Variant 3 | NULL | NULL | NULL |
Variant 4 | NULL | USA | NULL |
Variant 5 | NULL | USA | NULL |
Variant 6 | NULL | NULL | 001 |
Variant 7 | NULL | NULL | 001 |
SRWhseTable | SRWhseException | SRAgreementUnit | SRScaleUM |
---|---|---|---|
NULL | NULL | G | NULL |
A01 | NULL | G | NULL |
A01 | NULL | G | NULL |
A01 | NULL | G | NULL |
A01 | NULL | G | NULL |
NULL | NULL | G | NULL |
NULL | NULL | Q | EA |
SRPayingUnit | SRGuaranteedRebateRate | SRCurrency | SRExchangeRateType |
---|---|---|---|
G | NULL | USD | 1 |
G | NULL | USD | 1 |
G | NULL | USD | 1 |
G | NULL | USD | 1 |
G | NULL | USD | 1 |
G | NULL | USD | 1 |
G | NULL | USD | 1 |
SRIncludeReturns | SRPayee | SRPaymentMethod | SRPaymentTerms |
---|---|---|---|
0 | Y90001 | CH1 | N30 |
0 | Y90001 | CH1 | N30 |
0 | Y90001 | CH1 | N30 |
0 | Y90001 | CH1 | N30 |
0 | Y90001 | CH1 | N30 |
0 | Y90001 | CH1 | N30 |
0 | Y90001 | CH1 | N30 |
SRMaxRebateAmt | SRMinRebateAmt | SRRebateManager | SREmailAddrBuying |
---|---|---|---|
0 | 0 | NULL | NULL |
0 | 0 | NULL | NULL |
0 | 0 | NULL | NULL |
0 | 0 | NULL | NULL |
0 | 0 | NULL | NULL |
0 | 0 | NULL | NULL |
0 | 0 | NULL | NULL |
SRExpAlertIndBuying | SRExpDaysBuying | SRCompAlertIndBuying | SRCompletionRateBuying |
---|---|---|---|
0 | NULL | 0 | NULL |
0 | NULL | 0 | NULL |
0 | NULL | 0 | NULL |
0 | NULL | 0 | NULL |
0 | NULL | 0 | NULL |
0 | NULL | 0 | NULL |
0 | NULL | 0 | NULL |
SRSupplierContact | SREmailAddrSupplying | SRExpAlertIndSupplying | SRExpDaysSupplying |
---|---|---|---|
NULL | NULL | 0 | NULL |
NULL | NULL | 0 | NULL |
NULL | NULL | 0 | NULL |
NULL | NULL | 0 | NULL |
NULL | NULL | 0 | NULL |
NULL | NULL | 0 | NULL |
NULL | NULL | 0 | NULL |
SRCompAlertIndSupplying | SRCompletionRateSupplying | SRRebateMethod | SRScale |
---|---|---|---|
0 | NULL | FR | NULL |
0 | NULL | FR | NULL |
0 | NULL | FR | NULL |
0 | NULL | FR | NULL |
0 | NULL | SR | ZBST1 |
0 | NULL | SR | ZBST1 |
0 | NULL | SR | ZBST1 |
SRRebateCalcPercent | SRRebateCalcAmt | SRPOCategory | SRPOCategoryTable |
---|---|---|---|
5 | NULL | NULL | NULL |
5 | NULL | NULL | NULL |
7 | NULL | NULL | NULL |
8 | NULL | NULL | NULL |
NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL |